/*
 Navicat Premium Data Transfer

 Source Server         : fbl_mac
 Source Server Type    : MySQL
 Source Server Version : 50731 (5.7.31-log)
 Source Host           : localhost:3306
 Source Schema         : couple-game

 Target Server Type    : MySQL
 Target Server Version : 50731 (5.7.31-log)
 File Encoding         : 65001

 Date: 02/04/2025 14:03:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
DROP TABLE IF EXISTS `gen_table`;
CREATE TABLE `gen_table` (
  `table_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_name` varchar(200) DEFAULT '' COMMENT '表名称',
  `table_comment` varchar(500) DEFAULT '' COMMENT '表描述',
  `class_name` varchar(100) DEFAULT '' COMMENT '实体类名称',
  `tpl_category` varchar(200) DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）',
  `package_name` varchar(100) DEFAULT NULL COMMENT '生成包路径',
  `module_name` varchar(30) DEFAULT NULL COMMENT '生成模块名',
  `business_name` varchar(30) DEFAULT NULL COMMENT '生成业务名',
  `function_name` varchar(50) DEFAULT NULL COMMENT '生成功能名',
  `function_author` varchar(50) DEFAULT NULL COMMENT '生成功能作者',
  `gen_type` char(1) DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
  `gen_path` varchar(200) DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
  `options` varchar(1000) DEFAULT NULL COMMENT '其它生成选项',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`table_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='代码生成业务表';

-- ----------------------------
-- Records of gen_table
-- ----------------------------
BEGIN;
INSERT INTO `gen_table` (`table_id`, `table_name`, `table_comment`, `class_name`, `tpl_category`, `package_name`, `module_name`, `business_name`, `function_name`, `function_author`, `gen_type`, `gen_path`, `options`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (38, 'risks_identification', '隐患排查', 'RisksIdentification', 'crud', 'com.demo.generator.code', 'code', 'identification', '隐患排查', 'fbl', '0', '/', NULL, 'admin', '2024-03-26 10:04:13', '', NULL, NULL);
INSERT INTO `gen_table` (`table_id`, `table_name`, `table_comment`, `class_name`, `tpl_category`, `package_name`, `module_name`, `business_name`, `function_name`, `function_author`, `gen_type`, `gen_path`, `options`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (39, 'check_report', '企业报告表', 'CheckReport', 'crud', 'com.demo.generator.code', 'code', 'report', '企业报告', 'fbl', '0', '/', NULL, 'admin', '2024-03-29 09:39:23', '', NULL, NULL);
INSERT INTO `gen_table` (`table_id`, `table_name`, `table_comment`, `class_name`, `tpl_category`, `package_name`, `module_name`, `business_name`, `function_name`, `function_author`, `gen_type`, `gen_path`, `options`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (40, 'leak_table', '物质泄露表', 'LeakTable', 'crud', 'com.demo.generator.code', 'code', 'table', '物质泄露', 'fbl', '0', '/', NULL, 'admin', '2024-05-16 09:35:34', '', NULL, NULL);
INSERT INTO `gen_table` (`table_id`, `table_name`, `table_comment`, `class_name`, `tpl_category`, `package_name`, `module_name`, `business_name`, `function_name`, `function_author`, `gen_type`, `gen_path`, `options`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (41, 'leak_table_supplement', '泄露表补充物质泄露情况', 'LeakTableSupplement', 'crud', 'com.demo.generator.code', 'code', 'supplement', '泄露补充物质泄露情况', 'fbl', '0', '/', NULL, 'admin', '2024-05-16 14:42:59', '', NULL, NULL);
INSERT INTO `gen_table` (`table_id`, `table_name`, `table_comment`, `class_name`, `tpl_category`, `package_name`, `module_name`, `business_name`, `function_name`, `function_author`, `gen_type`, `gen_path`, `options`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (42, 'leak_table_base', '危险物品泄露应急处置方案基本信息', 'LeakTableBase', 'crud', 'com.demo.generator.code', 'code', 'base', '危险物品泄露应急处置方案基本信息', 'fbl', '0', '/', NULL, 'admin', '2025-02-21 10:45:46', '', NULL, NULL);
INSERT INTO `gen_table` (`table_id`, `table_name`, `table_comment`, `class_name`, `tpl_category`, `package_name`, `module_name`, `business_name`, `function_name`, `function_author`, `gen_type`, `gen_path`, `options`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (43, 'leak_water_toxic', '与水反应产生有毒气体的物质（表2）', 'LeakWaterToxic', 'crud', 'com.demo.generator.code', 'code', 'toxic', '与水反应产生有毒气体的物质（2）', 'fbl', '0', '/', NULL, 'admin', '2025-02-22 07:40:00', '', NULL, NULL);
INSERT INTO `gen_table` (`table_id`, `table_name`, `table_comment`, `class_name`, `tpl_category`, `package_name`, `module_name`, `business_name`, `function_name`, `function_author`, `gen_type`, `gen_path`, `options`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (44, 'leak_goods_lead', '危险货物与引导号关系对应表', 'LeakGoodsLead', 'crud', 'com.demo.generator.code', 'code', 'lead', '危险货物与引导号关系对应', 'fbl', '0', '/', NULL, 'admin', '2025-02-24 09:58:25', '', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for gen_table_column
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_column`;
CREATE TABLE `gen_table_column` (
  `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_id` varchar(64) DEFAULT NULL COMMENT '归属表编号',
  `column_name` varchar(200) DEFAULT NULL COMMENT '列名称',
  `column_comment` varchar(500) DEFAULT NULL COMMENT '列描述',
  `column_type` varchar(100) DEFAULT NULL COMMENT '列类型',
  `java_type` varchar(500) DEFAULT NULL COMMENT 'JAVA类型',
  `java_field` varchar(200) DEFAULT NULL COMMENT 'JAVA字段名',
  `is_pk` char(1) DEFAULT NULL COMMENT '是否主键（1是）',
  `is_increment` char(1) DEFAULT NULL COMMENT '是否自增（1是）',
  `is_required` char(1) DEFAULT NULL COMMENT '是否必填（1是）',
  `is_insert` char(1) DEFAULT NULL COMMENT '是否为插入字段（1是）',
  `is_edit` char(1) DEFAULT NULL COMMENT '是否编辑字段（1是）',
  `is_list` char(1) DEFAULT NULL COMMENT '是否列表字段（1是）',
  `is_query` char(1) DEFAULT NULL COMMENT '是否查询字段（1是）',
  `query_type` varchar(200) DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
  `html_type` varchar(200) DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
  `dict_type` varchar(200) DEFAULT '' COMMENT '字典类型',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`column_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=524 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='代码生成业务表字段';

-- ----------------------------
-- Records of gen_table_column
-- ----------------------------
BEGIN;
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (431, '38', 'id', NULL, 'int(11)', 'Integer', 'id', '1', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 1, 'admin', '2024-03-26 10:04:13', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (432, '38', 'specialty', '专业', 'varchar(255)', 'String', 'specialty', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 2, 'admin', '2024-03-26 10:04:13', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (433, '38', 'identification_type', '隐患分类', 'tinyint(2)', 'Integer', 'identificationType', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 3, 'admin', '2024-03-26 10:04:13', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (434, '38', 'identification_desc', '常见隐患描述', 'varchar(255)', 'String', 'identificationDesc', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 4, 'admin', '2024-03-26 10:04:13', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (435, '38', 'judge_proof', '判定依据', 'varchar(255)', 'String', 'judgeProof', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 5, 'admin', '2024-03-26 10:04:13', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (436, '38', 'identification_level', '隐患分级', 'tinyint(1)', 'Boolean', 'identificationLevel', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 6, 'admin', '2024-03-26 10:04:13', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (437, '38', 'identification_picture', '典型隐患照片', 'varchar(255)', 'String', 'identificationPicture', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 7, 'admin', '2024-03-26 10:04:13', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (438, '38', 'demonstrate_picture', '示范照片', 'varchar(255)', 'String', 'demonstratePicture', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 8, 'admin', '2024-03-26 10:04:13', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (439, '38', 'ramark', '备注', 'varchar(255)', 'String', 'ramark', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 9, 'admin', '2024-03-26 10:04:13', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (440, '38', 'create_time', '创建时间', 'timestamp', 'Timestamp', 'createTime', '0', '0', '1', NULL, NULL, NULL, NULL, 'EQ', NULL, '', 10, 'admin', '2024-03-26 10:04:13', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (441, '38', 'update_time', '修改时间', 'timestamp', 'Timestamp', 'updateTime', '0', '0', '1', NULL, NULL, NULL, NULL, 'EQ', NULL, '', 11, 'admin', '2024-03-26 10:04:13', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (442, '39', 'id', NULL, 'int(11)', 'Integer', 'id', '1', '1', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 1, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (443, '39', 'entpr_name', '企业名称', 'varchar(255)', 'String', 'entprName', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 2, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (444, '39', 'check_time', '检查时间', 'timestamp', 'Timestamp', 'checkTime', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 3, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (445, '39', 'check_user', '检查组人员id', 'varchar(255)', 'String', 'checkUser', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 4, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (446, '39', 'check_user_leader', '检查组人员负责人id', 'varchar(255)', 'String', 'checkUserLeader', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 5, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (447, '39', 'task_reason', '任务由来', 'text', 'String', 'taskReason', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 6, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (448, '39', 'check_aim', '检查目的', 'text', 'String', 'checkAim', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 7, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (449, '39', 'entpr_situation', '企业基本情况', 'text', 'String', 'entprSituation', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 8, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (450, '39', 'risk_id', '涉及隐患的id', 'varchar(255)', 'String', 'riskId', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 9, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (451, '39', 'situation_desc', '情况概述', 'text', 'String', 'situationDesc', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 10, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (452, '39', 'check_content', '检查具体内容', 'text', 'String', 'checkContent', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 11, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (453, '39', 'problems_key', '主要问题', 'text', 'String', 'problemsKey', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 12, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (454, '39', 'advise_measure', '整改建议措施', 'text', 'String', 'adviseMeasure', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 13, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (455, '39', 'attachment', '附件', 'varchar(255)', 'String', 'attachment', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 14, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (456, '39', 'report_status', '0 一般企业报告表 1 化工企业报告表', 'tinyint(1)', 'Boolean', 'reportStatus', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 15, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (457, '39', 'create_time', '创建时间', 'timestamp', 'Timestamp', 'createTime', '0', '0', '1', NULL, NULL, NULL, NULL, 'EQ', NULL, '', 16, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (458, '39', 'update_time', '修改时间', 'timestamp', 'Timestamp', 'updateTime', '0', '0', '1', NULL, NULL, NULL, NULL, 'EQ', NULL, '', 17, 'admin', '2024-03-29 09:39:23', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (459, '40', 'id', NULL, 'int(11)', 'Integer', 'id', '1', '1', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 1, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (460, '40', 'UN', 'UN号', 'char(4)', 'String', 'un', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 2, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (461, '40', 'lead_num', '引导号', 'int(11)', 'Integer', 'leadNum', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 3, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (462, '40', 'chemistry_name', '物质名称', 'varchar(255)', 'String', 'chemistryName', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 4, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (463, '40', 'every_direction_m_small', '小量泄漏（≤208L）各个方向隔离距离：米', 'varchar(255)', 'String', 'everyDirectionMSmall', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 5, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (464, '40', 'every_direction_ft_small', '小量泄漏（≤208L）各个方向隔离距离：英尺', 'varchar(255)', 'String', 'everyDirectionFtSmall', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 6, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (465, '40', 'down_direction_km_small_day', '小量泄漏（≤208L）白天下风向隔离距离：千米', 'varchar(255)', 'String', 'downDirectionKmSmallDay', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 7, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (466, '40', 'down_direction_mi_small_day', '小量泄漏（≤208L）白天下风向隔离距离：英里', 'varchar(255)', 'String', 'downDirectionMiSmallDay', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 8, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (467, '40', 'down_direction_km_small_night', '小量泄漏（≤208L）夜晚下风向隔离距离：千米', 'varchar(255)', 'String', 'downDirectionKmSmallNight', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 9, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (468, '40', 'down_direction_mi_small_night', '小量泄漏（≤208L）夜晚下风向隔离距离：英里', 'varchar(255)', 'String', 'downDirectionMiSmallNight', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 10, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (469, '40', 'every_direction_m_big', '大量泄漏（>208L）各个方向隔离距离：米', 'varchar(255)', 'String', 'everyDirectionMBig', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 11, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (470, '40', 'every_direction_ft_big', '大量泄漏（>208L）各个方向隔离距离：英尺', 'varchar(255)', 'String', 'everyDirectionFtBig', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 12, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (471, '40', 'down_direction_km_big_day', '大量泄漏（>208L）白天下风向隔离距离：千米', 'varchar(255)', 'String', 'downDirectionKmBigDay', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 13, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (472, '40', 'down_direction_mi_big_day', '大量泄漏（>208L）白天下风向隔离距离：英里', 'varchar(255)', 'String', 'downDirectionMiBigDay', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 14, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (473, '40', 'down_direction_km_big_night', '大量泄漏（>208L）夜晚下风向隔离距离：千米', 'varchar(255)', 'String', 'downDirectionKmBigNight', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 15, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (474, '40', 'down_direction_mi_big_night', '大量泄漏（>208L）夜晚下风向隔离距离：英里', 'varchar(255)', 'String', 'downDirectionMiBigNight', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 16, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (475, '40', 'create_time', '创建时间', 'timestamp', 'Timestamp', 'createTime', '0', '0', '1', NULL, NULL, NULL, NULL, 'EQ', NULL, '', 17, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (476, '40', 'update_time', '修改时间', 'timestamp', 'Timestamp', 'updateTime', '0', '0', '1', NULL, NULL, NULL, NULL, 'EQ', NULL, '', 18, 'admin', '2024-05-16 09:35:34', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (477, '41', 'id', 'id', 'int(11)', 'Integer', 'id', '1', '1', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 1, 'admin', '2024-05-16 14:42:59', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (478, '41', 'leak_id', '泄露物质id', 'int(11)', 'Integer', 'leakId', '0', '0', '1', NULL, NULL, NULL, NULL, 'EQ', NULL, '', 2, 'admin', '2024-05-16 14:42:59', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (479, '41', 'transport_basket', '运输容器', 'varchar(255)', 'String', 'transportBasket', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 3, 'admin', '2024-05-16 14:42:59', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (480, '41', 'every_direction_m', '所有风向初始隔离距离(m)', 'int(11)', 'Integer', 'everyDirectionM', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 4, 'admin', '2024-05-16 14:42:59', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (481, '41', 'low_day', '低风速白天防护距离（km）（<10km/h）', 'int(11)', 'Integer', 'lowDay', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 5, 'admin', '2024-05-16 14:42:59', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (482, '41', 'middle_day', '中风速白天防护距离（km）（10~20km/h）', 'int(11)', 'Integer', 'middleDay', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 6, 'admin', '2024-05-16 14:42:59', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (483, '41', 'hight_day', '高风速白天防护距离（km）（> 20km/h）', 'int(11)', 'Integer', 'hightDay', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 7, 'admin', '2024-05-16 14:42:59', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (484, '41', 'low_night', '低风速夜晚防护距离（km）（<10km/h）', 'int(11)', 'Integer', 'lowNight', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 8, 'admin', '2024-05-16 14:42:59', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (485, '41', 'middle_night', '中风速夜晚防护距离（km）（10~20km/h）', 'int(11)', 'Integer', 'middleNight', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 9, 'admin', '2024-05-16 14:42:59', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (486, '41', 'hight_night', '高风速夜晚防护距离（km）（> 20km/h）', 'int(11)', 'Integer', 'hightNight', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 10, 'admin', '2024-05-16 14:42:59', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (487, '42', 'id', 'id', 'int(11)', 'Integer', 'id', '1', '1', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 1, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (488, '42', 'lead_num', '引导号', 'varchar(4)', 'String', 'leadNum', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 2, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (489, '42', 'type_ describe', '类别描述', 'varchar(255)', 'String', 'type describe', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 3, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (490, '42', 'fire_bomb', '火灾或爆炸', 'varchar(255)', 'String', 'fireBomb', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 4, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (491, '42', 'health', '健康', 'varchar(255)', 'String', 'health', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 5, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (492, '42', 'safety', '公共安全', 'varchar(255)', 'String', 'safety', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 6, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (493, '42', 'protect', '个体防护', 'varchar(255)', 'String', 'protect', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 7, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (494, '42', 'evacuate', '疏散', 'varchar(255)', 'String', 'evacuate', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 8, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (495, '42', 'safety_big_leak', '公共安全大量泄露', 'varchar(255)', 'String', 'safetyBigLeak', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 9, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (496, '42', 'safety_fire', '公共安全火灾', 'varchar(255)', 'String', 'safetyFire', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 10, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (497, '42', 'emergency_fire', '应急响应火灾', 'varchar(255)', 'String', 'emergencyFire', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 11, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (498, '42', 'small_fire', '小火灾', 'varchar(255)', 'String', 'smallFire', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 12, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (499, '42', 'big_fire', '大火灾', 'varchar(255)', 'String', 'bigFire', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 13, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (500, '42', 'tank_car_fire', '储罐或槽车/拖车火灾', 'varchar(255)', 'String', 'tankCarFire', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 14, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (501, '42', 'spill\nspill\nspill_leak', '溅出或泄漏', 'varchar(255)', 'String', 'spill\nspill\nspillLeak', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 15, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (502, '42', 'emergency_small_leak', '应急响应小量泄漏', 'varchar(255)', 'String', 'emergencySmallLeak', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 16, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (503, '42', 'emergency_big_leak', '应急响应大量泄漏', 'varchar(255)', 'String', 'emergencyBigLeak', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 17, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (504, '42', 'first_aid', '急救', 'varchar(255)', 'String', 'firstAid', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 18, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (505, '42', 'remark', '补充信息 备注', 'varchar(255)', 'String', 'remark', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 19, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (506, '42', 'create_time', '创建时间', 'timestamp', 'Timestamp', 'createTime', '0', '0', '1', NULL, NULL, NULL, NULL, 'EQ', NULL, '', 20, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (507, '42', 'update_time', '修改时间', 'timestamp', 'Timestamp', 'updateTime', '0', '0', '1', NULL, NULL, NULL, NULL, 'EQ', NULL, '', 21, 'admin', '2025-02-21 10:45:46', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (508, '43', 'id', 'id', 'int(11)', 'Integer', 'id', '1', '1', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 1, 'admin', '2025-02-22 07:40:00', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (509, '43', 'UN', 'UN号', 'char(4)', 'String', 'un', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 2, 'admin', '2025-02-22 07:40:00', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (510, '43', 'UN_name', 'UN号名称', 'varchar(255)', 'String', 'unName', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 3, 'admin', '2025-02-22 07:40:00', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (511, '43', 'lead_num', '引导号', 'varchar(4)', 'String', 'leadNum', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 4, 'admin', '2025-02-22 07:40:00', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (512, '43', 'chemistry_name', '物质名称', 'varchar(255)', 'String', 'chemistryName', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 5, 'admin', '2025-02-22 07:40:00', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (513, '43', 'chemistry_num', '危序号', 'int(11)', 'Integer', 'chemistryNum', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 6, 'admin', '2025-02-22 07:40:00', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (514, '43', 'book_name', '《危化品目录（2015版）》品名', 'varchar(255)', 'String', 'bookName', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 7, 'admin', '2025-02-22 07:40:00', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (515, '43', 'toxic_gas', '产生的毒性气体', 'varchar(255)', 'String', 'toxicGas', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 8, 'admin', '2025-02-22 07:40:00', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (516, '43', 'remark', '备注', 'varchar(255)', 'String', 'remark', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 9, 'admin', '2025-02-22 07:40:00', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (517, '44', 'id', 'id', 'int(11)', 'Integer', 'id', '1', '1', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 1, 'admin', '2025-02-24 09:58:26', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (518, '44', 'UN', 'UN号', 'char(4)', 'String', 'un', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 2, 'admin', '2025-02-24 09:58:26', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (519, '44', 'lead_num', '引导号', 'varchar(4)', 'String', 'leadNum', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 3, 'admin', '2025-02-24 09:58:26', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (520, '44', 'chemistry_name', '物质名称', 'varchar(255)', 'String', 'chemistryName', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 4, 'admin', '2025-02-24 09:58:26', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (521, '44', 'wrm', '与水反应（表2关联）', 'int(11)', 'Integer', 'wrm', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 5, 'admin', '2025-02-24 09:58:26', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (522, '44', 'cwa', '作为武器使用 特殊危险性（0 没有 1 有）', 'int(11)', 'Integer', 'cwa', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 6, 'admin', '2025-02-24 09:58:26', '', NULL);
INSERT INTO `gen_table_column` (`column_id`, `table_id`, `column_name`, `column_comment`, `column_type`, `java_type`, `java_field`, `is_pk`, `is_increment`, `is_required`, `is_insert`, `is_edit`, `is_list`, `is_query`, `query_type`, `html_type`, `dict_type`, `sort`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (523, '44', 'tih', '毒物吸入危害泄露隔离距离（表1关联）', 'int(11)', 'Integer', 'tih', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', NULL, '', 7, 'admin', '2025-02-24 09:58:26', '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID',
  `job_name` varchar(64) NOT NULL DEFAULT '' COMMENT '任务名称',
  `job_group` varchar(64) NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',
  `cron_expression` varchar(255) DEFAULT '' COMMENT 'cron执行表达式',
  `misfire_policy` varchar(20) DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
  `concurrent` char(1) DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1暂停）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注信息',
  PRIMARY KEY (`job_id`,`job_name`,`job_group`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='定时任务调度表';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_job` (`job_id`, `job_name`, `job_group`, `invoke_target`, `cron_expression`, `misfire_policy`, `concurrent`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '测试定时任务', 'baolin fan', 'TaskTest.noParams', '0/10 * * * * ?', '1', '1', '1', 'admin', '2024-03-29 10:12:08', '', NULL, '');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
